IF NOT EXISTS(SELECT * FROM sys.sysobjects WHERE name ='STIUnitMaping' and xtype='U')
Begin
	CREATE TABLE [dbo].[STIUnitMaping](
	[UnitCode] [SMALLINT] NOT NULL,
	[TaxCode] [SMALLINT] NULL,
	[TaxName] [NVARCHAR](100) NULL,
	[CreatedBy] [SMALLINT] NULL,
	[CreatedOn] [DATETIME] NULL,
 CONSTRAINT [PK_STIUnitMaping] PRIMARY KEY CLUSTERED 
(
	[UnitCode] ASC
) ON [PRIMARY]
) ON [PRIMARY] 


ALTER TABLE [dbo].[STIUnitMaping] ADD  CONSTRAINT [DF_STIUnitMaping_CreatedOn]  DEFAULT (GETDATE()) FOR [CreatedOn]

END
